Nightingale Ice Cream:
Mind the Gap
📝 Overview
This analysis provides a structured, data-driven approach to identifying and quantifying distribution shortfalls across the Nightingale Ice Cream portfolio within Kroger divisions. Using SPINS weekly sales data (1/19/2025–10/5/2025) and KeHE shipment data from the Ellettsville DC (1/1/2025–11/5/2025), the report isolates where distribution has previously been achieved, where it has fallen short, and the likely operational or supply-chain causes.
Because SPINS measures selling stores and KeHE measures ordering and fulfillment, the two systems do not align perfectly. For that reason, the most reliable performance anchor in this analysis is the Distribution Gap metric: the difference between the maximum proven distribution (Store Ceiling) and the actual weekly distribution. This allows us to quantify the store-weeks of lost availability and prioritize the items with the highest recoverable opportunity.
📦 Fill Rate Performance: The Supply Chain Diagnosis (KeHE data)
Goal: Determine whether distribution losses originate upstream (DC supply availability) or downstream (store-level execution).
This section summarizes KeHE fill rate performance by Area and Item. A low fill rate indicates that the DC shipped fewer cases than were ordered, which can signal supply constraints, ordering errors, or temporary out-of-stocks at the warehouse level.
Important Clarification:
A high fill rate generally rules out DC backlog as the primary cause of distribution loss, but it does not guarantee that: the DC always had inventory available throughout the week, stores ordered the correct quantities, or stores remained in stock long enough to generate SPINS sales.
Thus, Fill Rate is a directional diagnostic, not a complete confirmation of supply-chain health.
| Area | Item | NumOfStores | Shipped | Ordered | FillRate |
|---|---|---|---|---|---|
| Kroger Atlanta | 10.4 OZ ICE CRM SNDWCH STRWBRY SC (860006870447) | 167 | 12,432 | 12,432 | 100.0% |
| Kroger Atlanta | 10.4 OZ ICE CREAM SWCH CK MNSTR (860006870423) | 176 | 12,607 | 12,852 | 98.1% |
| Kroger Atlanta | 10.8 OZ ICE CRM SNDWCH CHOC BLCKT (860006870454) | 176 | 8,666 | 8,869 | 97.7% |
| Kroger Atlanta | 10.5 OZ SANDWHICHES IC BANA PDNG (850037507283) | 176 | 16,639 | 17,255 | 96.4% |
| Kroger Atlanta | 10.1 OZ SANDWICHES IC MCHA BRWN (850037507290) | 139 | 5,719 | 6,202 | 92.2% |
| Area | Item | NumOfStores | Shipped | Ordered | FillRate |
|---|---|---|---|---|---|
| Kroger Central | 10.8 OZ ICE CRM SNDWCH CHOC BLCKT (860006870454) | 117 | 4,340 | 4,340 | 100.0% |
| Kroger Central | 10.1 OZ SANDWICHES IC MCHA BRWN (850037507290) | 69 | 2,254 | 2,289 | 98.5% |
| Kroger Central | 10.4 OZ ICE CRM SNDWCH STRWBRY SC (860006870447) | 107 | 5,271 | 5,383 | 97.9% |
| Kroger Central | 10.4 OZ ICE CREAM SWCH CK MNSTR (860006870423) | 117 | 5,859 | 6,006 | 97.6% |
| Kroger Central | 10.5 OZ SANDWHICHES IC BANA PDNG (850037507283) | 117 | 9,576 | 9,835 | 97.4% |
| Area | Item | NumOfStores | Shipped | Ordered | FillRate |
|---|---|---|---|---|---|
| Kroger Cincinnati | 10.4 OZ ICE CREAM SWCH CK MNSTR (860006870423) | 102 | 5,964 | 6,069 | 98.3% |
| Kroger Cincinnati | 10.8 OZ ICE CRM SNDWCH CHOC BLCKT (860006870454) | 102 | 3,836 | 3,920 | 97.9% |
| Kroger Cincinnati | 10.4 OZ ICE CRM SNDWCH STRWBRY SC (860006870447) | 102 | 5,285 | 5,418 | 97.5% |
| Kroger Cincinnati | 10.1 OZ SANDWICHES IC MCHA BRWN (850037507290) | 96 | 2,954 | 3,031 | 97.5% |
| Kroger Cincinnati | 10.5 OZ SANDWHICHES IC BANA PDNG (850037507283) | 102 | 8,484 | 8,988 | 94.4% |
| Area | Item | NumOfStores | Shipped | Ordered | FillRate |
|---|---|---|---|---|---|
| Kroger Columbus | 10.4 OZ ICE CREAM SWCH CK MNSTR (860006870423) | 104 | 5,124 | 5,152 | 99.5% |
| Kroger Columbus | 10.1 OZ SANDWICHES IC MCHA BRWN (850037507290) | 81 | 2,513 | 2,527 | 99.4% |
| Kroger Columbus | 10.8 OZ ICE CRM SNDWCH CHOC BLCKT (860006870454) | 104 | 4,102 | 4,151 | 98.8% |
| Kroger Columbus | 10.4 OZ ICE CRM SNDWCH STRWBRY SC (860006870447) | 83 | 3,913 | 3,997 | 97.9% |
| Kroger Columbus | 10.5 OZ SANDWHICHES IC BANA PDNG (850037507283) | 104 | 8,659 | 9,065 | 95.5% |
| Area | Item | NumOfStores | Shipped | Ordered | FillRate |
|---|---|---|---|---|---|
| Kroger Delta | 10.8 OZ ICE CRM SNDWCH CHOC BLCKT (860006870454) | 76 | 3,332 | 3,332 | 100.0% |
| Kroger Delta | 10.4 OZ ICE CRM SNDWCH STRWBRY SC (860006870447) | 76 | 5,397 | 5,439 | 99.2% |
| Kroger Delta | 10.4 OZ ICE CREAM SWCH CK MNSTR (860006870423) | 89 | 5,446 | 5,509 | 98.9% |
| Kroger Delta | 10.5 OZ SANDWHICHES IC BANA PDNG (850037507283) | 89 | 8,925 | 9,331 | 95.6% |
| Kroger Delta | 10.1 OZ SANDWICHES IC MCHA BRWN (850037507290) | 58 | 2,324 | 2,485 | 93.5% |
| Area | Item | NumOfStores | Shipped | Ordered | FillRate |
|---|---|---|---|---|---|
| Kroger Dillon | 10.4 OZ ICE CRM SNDWCH STRWBRY SC (860006870447) | 52 | 2,289 | 2,289 | 100.0% |
| Kroger Dillon | 10.4 OZ ICE CREAM SWCH CK MNSTR (860006870423) | 67 | 2,772 | 2,786 | 99.5% |
| Kroger Dillon | 10.1 OZ SANDWICHES IC MCHA BRWN (850037507290) | 33 | 1,141 | 1,155 | 98.8% |
| Kroger Dillon | 10.8 OZ ICE CRM SNDWCH CHOC BLCKT (860006870454) | 67 | 2,233 | 2,338 | 95.5% |
| Kroger Dillon | 10.5 OZ SANDWHICHES IC BANA PDNG (850037507283) | 35 | 2,527 | 2,989 | 84.5% |
| Area | Item | NumOfStores | Shipped | Ordered | FillRate |
|---|---|---|---|---|---|
| Kroger Louisville | 10.8 OZ ICE CRM SNDWCH CHOC BLCKT (860006870454) | 76 | 2,737 | 2,744 | 99.7% |
| Kroger Louisville | 10.4 OZ ICE CREAM SWCH CK MNSTR (860006870423) | 82 | 3,724 | 3,801 | 98.0% |
| Kroger Louisville | 10.5 OZ SANDWHICHES IC BANA PDNG (850037507283) | 82 | 5,621 | 5,754 | 97.7% |
| Kroger Louisville | 10.4 OZ ICE CRM SNDWCH STRWBRY SC (860006870447) | 67 | 3,157 | 3,248 | 97.2% |
| Kroger Louisville | 10.1 OZ SANDWICHES IC MCHA BRWN (850037507290) | 45 | 1,218 | 1,316 | 92.6% |
| Area | Item | NumOfStores | Shipped | Ordered | FillRate |
|---|---|---|---|---|---|
| Kroger Michigan | 10.8 OZ ICE CRM SNDWCH CHOC BLCKT (860006870454) | 103 | 4,333 | 4,333 | 100.0% |
| Kroger Michigan | 10.1 OZ SANDWICHES IC MCHA BRWN (850037507290) | 100 | 3,514 | 3,570 | 98.4% |
| Kroger Michigan | 10.5 OZ SANDWHICHES IC BANA PDNG (850037507283) | 111 | 11,130 | 11,403 | 97.6% |
| Kroger Michigan | 10.4 OZ ICE CREAM SWCH CK MNSTR (860006870423) | 111 | 6,804 | 6,986 | 97.4% |
| Kroger Michigan | 10.4 OZ ICE CRM SNDWCH STRWBRY SC (860006870447) | 90 | 6,286 | 6,482 | 97.0% |
| Area | Item | NumOfStores | Shipped | Ordered | FillRate |
|---|---|---|---|---|---|
| Kroger Mid-Atlantic | 10.8 OZ ICE CRM SNDWCH CHOC BLCKT (860006870454) | 68 | 8,022 | 8,022 | 100.0% |
| Kroger Mid-Atlantic | 10.4 OZ ICE CRM SNDWCH STRWBRY SC (860006870447) | 37 | 5,544 | 5,607 | 98.9% |
| Kroger Mid-Atlantic | 10.4 OZ ICE CREAM SWCH CK MNSTR (860006870423) | 88 | 13,216 | 13,391 | 98.7% |
| Kroger Mid-Atlantic | 10.5 OZ SANDWHICHES IC BANA PDNG (850037507283) | 88 | 14,021 | 15,106 | 92.8% |
| Kroger Mid-Atlantic | 10.1 OZ SANDWICHES IC MCHA BRWN (850037507290) | 37 | 4,186 | 4,522 | 92.6% |
| Area | Item | NumOfStores | Shipped | Ordered | FillRate |
|---|---|---|---|---|---|
| Kroger Nashville | 10.8 OZ ICE CRM SNDWCH CHOC BLCKT (860006870454) | 90 | 3,472 | 3,486 | 99.6% |
| Kroger Nashville | 10.4 OZ ICE CRM SNDWCH STRWBRY SC (860006870447) | 88 | 4,851 | 4,928 | 98.4% |
| Kroger Nashville | 10.4 OZ ICE CREAM SWCH CK MNSTR (860006870423) | 90 | 5,061 | 5,173 | 97.8% |
| Kroger Nashville | 10.1 OZ SANDWICHES IC MCHA BRWN (850037507290) | 67 | 2,163 | 2,261 | 95.7% |
| Kroger Nashville | 10.5 OZ SANDWHICHES IC BANA PDNG (850037507283) | 90 | 7,287 | 7,693 | 94.7% |
Products with consistently low fill rates—especially high-volume SKUs—should be prioritized for distributor coordination and replenishment planning before store-level corrective actions are pursued.
📈 Number of Stores Selling: Weekly Demand View (SPINS data)
Goal: Establish the highest level of verified selling distribution for each SKU in each market.
The Store Ceiling reflects the maximum number of stores that recorded a sale during the period. This metric tells us where the product has proven it can sell, regardless of current performance.
Key Notes: Store Ceiling represents maximum achieved selling distribution, not necessarily authorized space or full distribution potential. If current weekly distribution falls below this ceiling, the gap is potentially recoverable, assuming authorization and shelf placement have not changed. Items with high ceilings and low current distribution signal the strongest opportunity for near-term distribution recovery.
Use this chart to quickly surface SKUs that have demonstrated broad demand but are currently under-performing in weekly store count.
📉 Total Distribution Gap: Quantifying the Missed Opportunity (SPINS data)
Goal: Quantify the cumulative impact of distribution loss over time.
The Total Distribution Gap measures the number of store-weeks lost for each SKU:
(Max Stores – Actual Stores) aggregated across all weeks.
This does not represent dollar value directly, but it reflects the magnitude of availability loss. Higher gaps indicate sustained under-distribution relative to proven capability.
Important Clarification:
Because each store-week is weighted equally, this metric captures availability loss, not revenue loss. Velocity variation between stores is not reflected. Still, it is the most effective way to prioritize distribution recovery because it highlights chronic and widespread losses.
🎯 Individual Product Distribution Gap Analysis (SPINS data)
These visuals isolate the single most critical item in each market—the SKU with the highest Total Distribution Gap in the chart above—and track its weekly shortfall.
The gold section represents the number of stores that could have sold the product, but did not.
This view clarifies the pattern of failure:
Chronic gap: consistently low distribution vs. ceiling → likely systemic (planogram, ordering, replenishment). Acute gap: sudden drop then recovery → likely tied to a specific event (promo OOS, DC hiccup, reset window).
This step confirms whether the issue is ongoing or event-driven before remediation efforts begin.
Most Critical Item: Chmp Ckie Mnstr Snwch 2.6oz (4pk) (Total Gap: 1143 Store-Weeks)
Most Critical Item: Chmp Ckie Mnstr Snwch 2.6oz (4pk) (Total Gap: 1026 Store-Weeks)
Most Critical Item: Chocolate Blackout Iccrm Sandwiches 2.7oz (4pk) (Total Gap: 1019 Store-Weeks)
Most Critical Item: Chocolate Blackout Iccrm Sandwiches 2.7oz (4pk) (Total Gap: 973 Store-Weeks)
Most Critical Item: Strwbry Short Cake Ice Cream Sandwich 2.6oz (4pk) (Total Gap: 940 Store-Weeks)
Most Critical Item: Ice Cream Sandwiches Mocha Brownie Chomp Size 2.5 Oz (4pk) (Total Gap: 904 Store-Weeks)
Most Critical Item: Chmp Ckie Mnstr Snwch 2.6oz (4pk) (Total Gap: 826 Store-Weeks)
Most Critical Item: Chmp Ckie Mnstr Snwch 2.6oz (4pk) (Total Gap: 702 Store-Weeks)
Most Critical Item: Ice Cream Sandwich Banana Pudding 2.6 Oz (4pk) (Total Gap: 690 Store-Weeks)
Most Critical Item: Chmp Ckie Mnstr Snwch 2.6oz (4pk) (Total Gap: 583 Store-Weeks)
🔍 Distribution Gap Detailed View (SPINS data)
Goal: Provide the auditable, filterable data behind all visuals for store-level or week-level investigation.
Each row reflects a single SKU-week and quantifies the exact shortfall in stores. This table allows teams to:
Validate patterns identified in the visuals
Investigate specific weeks with large gaps
Cross-reference with orders, resets, DC incidents, or merchandising changes
This tool is essential for root cause confirmation and should be used alongside the Fill Rate tables to determine whether the issue originates in supply or in-store execution.
🚀 Conclusion: Driving Distribution Recovery—The Strategic Mandate
Maximizing distribution requires a disciplined sequence of diagnostics grounded in proven performance. By anchoring on Store Ceiling, we establish what is demonstrably possible. From there, Total Distribution Gap quantifies the size of the prize, and Fill Rate/Weekly patterns help isolate whether supply constraints or in-store execution failures are driving the shortfall.
A two-step recovery process emerges:
- Prioritization & Confirmation
Target SKUs with the largest Total Distribution Gaps.
Validate whether supply issues exist using Fill Rate.
If supply is constrained, direct efforts upstream before intervening at store level.
- In-Depth Diagnosis & Validation
For SKUs with healthy supply, analyze weekly patterns to determine whether gaps are chronic or event-driven.
Use the detailed table to pinpoint exact weeks of failure and tie them to operational events, resets, or merchandising gaps.
Following this structured approach prevents misallocation of effort and allows the team to recover distribution efficiently, restore products to their proven ceilings, and unlock the full revenue potential in the market.